[dbo].[PanelDefinition]

Property	Value
Created	7:29:57 AM Saturday, August 21, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Property

Value

Created

7:29:57 AM Saturday, August 21, 2010

Last Modified

11:40:05 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)	Default
PanelDefinitionId	uniqueidentifier	16	(newid())
Name	nvarchar(50)	100
Description	nvarchar(500)	1000
RelatedEntityName	nvarchar(50)	100
SerializedPanelDefinition	nvarchar(max)	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

PanelDefinitionId

uniqueidentifier

(newid())

Name

nvarchar(50)

100

Description

nvarchar(500)

1000

RelatedEntityName

nvarchar(50)

100

SerializedPanelDefinition

nvarchar(max)

max

	Name	Columns	Unique
	PK_PanelDefinition	PanelDefinitionId

Name

Columns

Unique

PK_PanelDefinition

PanelDefinitionId

SQL Script

CREATE TABLE [dbo].[PanelDefinition]
(
[PanelDefinitionId] [uniqueidentifier] NOT NULL CONSTRAINT [DF_PanelDefinition_PanelDefinitionId] DEFAULT (newid()),
[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RelatedEntityName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerializedPanelDefinition] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[PanelDefinition] ADD CONSTRAINT [PK_PanelDefinition] PRIMARY KEY CLUSTERED ([PanelDefinitionId]) ON [PRIMARY]
GO